=hyperlink(“https://t.co/axJltTNvCM”&year(A2)&right(“00″&month(A2),2)&right(“00″&DAY(A2),2)&”T”&right(“00″&hour(A2),2)&right(“00″&minute(A2),2)&”00/”&year(B2)&right(“00″&month(B2),2)&right(“00″&DAY(B2),2)&”T”&right(“00″&hour(B2),2)&right(“00″&minute(B2),2)&”00&ctz=Japan/Tokyo&

2020-09-01 aki

=hyperlink("https://t.co/axJltTNvCM"&year(A2)&right("00"&month(A2),2)&right("00"&DAY(A2),2)&"T"&right("00"&hour(A2),2)&right("00"&minute(A2),2)&"00/"&year(B2)&right("00"&month(B2),2)&right("00"&DAY(B2),2)&"T"&right("00"&hour(B2),2)&right("00"&minute(B2),2)&"00&ctz=Japan/Tokyo&

— Akihiko SHIRAI, Ph.D #VTC20 (@o_ob) September 1, 2020

from Twitter https://twitter.com/o_ob